Disclaimer

* I am sharing my personal views not the views of RenaissanceRe 
  or any of its subsidiary companies.
  
* Thought provoking only: The materials are provided for information 
  purposes only and are in summary form.
  
* This is not consulting: No representations or warranties are given. 
  If you want to use these ideas, hire a pro.
  
* This is not financial advice: No financial advice is being given 
  nor any recommendation to invest in any product. 
  
* Historical data is no assurance as to future results.

Source

JD’s Lema:

To migrate Excel analysts to R, help them be better at Excel first.

Then help them use a bit of R for the painful parts. If you fail to migrate them to R you will at least have better Excel!

Fail Safe!

@cmastication

Corporations Are Sad Silos

Art by Allison Horst

JD’s Lema:

To migrate Excel analysts to R, help them be better at Excel first.

Then help them use a bit of R for the painful parts. If you fail to migrate them to R you will at least have better Excel!

Fail Safe!

But that R Environemnt Though…

Jupyter Lab Loves R

How To?

library(tidyverse)
library(openxlsx)
wb <- loadWorkbook("iris_wb.xlsx")

Write & Save

writeDataTable(
  wb = wb,
  sheet = 'iris_sheet',
  x = iris,
  startCol = 1,
  startRow = 1,
  tableStyle = "TableStyleLight9",
  tableName = 'iris_table')
saveWorkbook(wb = wb,
             file = "iris_wb.xlsx",
             overwrite = T)

https://xkcd.com/1205/


(Wrong) Assumptions:

  • All time is of equal value and is interchangeable

  • Current frequency of reporting = future freq

  • All time spent doing analytics is of equal utility
    • Are all tasks equal?
  • Automated and manual workflows produce the same product
    • errors?

It looks like you’re doing a data science!

Would you like me to format your integers as dates?!?

Art by Allison Horst: @allison_horst

All drawn digitally with Procreate on iPad…

Art by Allison Horst @allison_horst